<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>学生信息列表</title>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
</head>
<body>
    <h1>学生信息列表</h1>
    <table class="table">
        <thead>
            <tr>
                <th>编号</th>
                <th>姓名</th>
                <th>性别</th>
                <th>年龄</th>
                <th>籍贯</th>
                <th>班级</th>
                <th>联系电话</th>
                <th>操作</th>
            </tr>
        </thead>
        <tbody>
            {% for student in students %}
            <tr>
                <td>{{ student.Sno }}</td>
                <td>{{ student.Sname }}</td>
                <td>{{ student.Ssex }}</td>
                <td>{{ student.Sage }}</td>
                <td>{{ student.Dno }}</td>
                <td>{{ student.Sclass }}</td>
                <td>{{ student.address }}</td>
                <td>
                    <a href="{{ url_for('edit_student', Sno=student.Sno) }}">修改</a>
                    <a href="{{ url_for('delete_student', Sno=student.Sno) }}">删除</a>
                </td>
            </tr>
            {% endfor %}
        </tbody>
    </table>
    <a href="{{ url_for('add_student') }}">添加</a>
</body>
</html>